Round 1: Technical Interviewc (30 mins to 1 hour)

🔹Tell me about yourself including your current project.

🔹Coding questions related to window function and you need to solve it using SQL and PySpark.

🔹Given a string 'AAAVGXFHHFSGFGGLK' find the non repeating letters from the string.

🔹You have a list [1,[2,3],4,5,6,[7,8,9]] convert to single list [1,2,3,4,5,6,7,8,9]

🔹Integration runtime in ADF, explain them.

🔹How you'll copy 1TB data daily?

🔹There are files and folders present in ADLS and you need to copy those files and folders how you'll do it?

Round 2: System Design Round

🔹Business is going to generate TBs of daily, How you'll design the data pipeline in Azure?

🔹We will be getting excel sheets which will be having multiple sheets, How'll you process the data? Design the data pipeline.

🔹What are the different data sources you have used?

🔹What are spark optimizations and explain them.

🔹Some design you can expect from our current project like what are the architecture you are following and why?

🔹What is unity catalog and how its implemented in your project.

Round 3: HR Discussion

🔹HR will request for the initial documents to release the offer letter. It'll include declaration forms and your previous offer letter etc.

Round 4: HR Compensation Negotiation

🔹HR will try to negotiate the salary as per the budget.

Tip:If you know your interview went well then you should also try to stick to your expectation and it works.